﻿<!DOCTYPE html>
<html>
	<head>
		<title>RIGHT/RIGHTB Function</title>
		<meta charset="utf-8" />
		<meta name="description" content="" />
		<link type="text/css" rel="stylesheet" href="../../../../../../common/main/resources/help/editor.css" />
		<link type = "text/css" rel = "stylesheet" href = "../../images/sprite.css" />
        <script type="text/javascript" src="../callback.js"></script>
        <script type="text/javascript" src="../search/js/page-search.js"></script>
	</head>
	<body>
		<div class="mainpart">
            <div class="search-field">
                <input id="search" class="searchBar" placeholder="Search" type="text" onkeypress="doSearch(event)">
            </div>
			<h1>RIGHT/RIGHTB Function</h1>
			<p>The <b>RIGHT/RIGHTB</b> function is one of the <a href="../UsageInstructions/InsertFunction.htm#textdata" onclick="onhyperlinkclick(this)">text and data functions</a>. Is used to extract a substring from a string starting from the right-most character, based on the specified number of characters. The <b>RIGHT</b> function is intended for languages that use the single-byte character set (SBCS), while <b>RIGHTB</b> - for languages that use the double-byte character set (DBCS) like Japanese, Chinese, Korean etc.</p>
			<h3>Syntax</h3> 
			<p><b><em>RIGHT(text, [num_chars])</em></b></p>
			<p>The <b>RIGHT</b> function has the following arguments:</p>
			<table style="width: 40%">
                <tr>
                    <th style="background-color: #f4f4f4" width="150ch"><b>Argument</b></th>
                    <th style="background-color: #f4f4f4"><b>Description</b></th>
                </tr>
                <tr>
                    <td><b><em>text</em></b></td>
                    <td>A string you need to extract the substring from.</td>
                </tr>
				<tr>
                    <td><b><em>num_chars</em></b></td>
                    <td>A number of the substring characters. It must be greater than or equal to 0. It is an optional argument. If it is omitted, the function will assume it to be 1.</td>
                </tr>
            </table>

            <p><b><em>RIGHTB(text, [num_bytes])</em></b></p>
            <p>The <b>RIGHTB</b> function has the following arguments:</p>
            <table style="width: 40%">
                <tr>
                    <th style="background-color: #f4f4f4" width="150ch"><b>Argument</b></th>
                    <th style="background-color: #f4f4f4"><b>Description</b></th>
                </tr>
                <tr>
                    <td><b><em>text</em></b></td>
                    <td>A string you need to extract the substring from.</td>
                </tr>
                <tr>
                    <td><b><em>num_bytes</em></b></td>
                    <td>A number of the substring characters, based on bytes. It is an optional argument.</td>
                </tr>
            </table>
			
			<h3>Notes</h3>
			<p><a href="../UsageInstructions/InsertFunction.htm#applyfunction" onclick="onhyperlinkclick(this)">How to apply</a> the <b>RIGHT/RIGHTB</b> function.</p>
			
			<h3>Examples</h3>
            <p>The figure below displays the result returned by the <b>RIGHT</b> function.</p>
            <p><img alt="RIGHT Function" src="../images/right.png" /></p>
		</div>
	</body>
</html>